EMT Practice Test

1. Question Content...

---

Question1: Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

Question2: What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

Question3: What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

Question4: How will you select a preference for Validation rules? Choose the correct answer

Question5: Why is not a key factor of ALV for HAN A? Please choose the correct answer.

Question6: User STUDENT_A create and activates a design-time object. In which schema is the run object generated?
Please choose the correct answer

Question7: Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.

Question8: Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

Question9: What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.

Question10: Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are
2 correct answers to this question.

Question11: What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

Question12: What is the purpose of an ABAP project in ABAP Development Tool for eclipse? There are 2 correct answers to this question

Question13: What is the central goal of using SAP HANA? Please choose the correct answer

Question14: What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.

Question15: What are the features associated with ABAP CDS? There are 3 correct answers to this question.

Question16: You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecesary load away from the database"? Choose the correct answer

Question17: What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

Question18: Which is not a Golden Rule for Open SQL? Please choose the correct answer.

Question19: What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

Question20: When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

Question21: The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies?
There are 3 correct answers to this question

Question22: DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

Question23: How to create a core data services view? (3 ans)

Question24: When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

Question25: Name some perspectives that are available in the SAP HANA Studio? (3 ans)

Question26: Which of the following is a limitation when you create an external view? Please choose the correct answer.

Question27: Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

Question28: In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

Question29: Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Choose the correct answer

Question30: Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.

Question31: How will you hide the attributes that are not required for client consumption? Choose the correct answer

Question32: Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.

Question33: What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

Question34: What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

Question35: You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

Question36: Which form of services is responsible for defining and consuming semantically rich data models? (1 ans)

Question37: What are the different views provided by the ABAP Profiling? There are 2 correct answers to this question.

Question38: Which of the following is not an element of Analytical view? Please choose the correct answer.

Question39: You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

Question40: Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question

Question41: Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.

Question42: Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.

Question43: What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.

Question44: Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question.

Question45: Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

Question46: What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

Question47: Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question

Question48: What made SAP HANA possible?

Question49: What output does the SAP HANA provide as a unique combination of hardware and software innovations?
Please choose the correct answer.

Question50: Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database?
There are 3 correct answers to this question.